package com.sgolub.commanndsonline.domain.ref.distinct;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.NamedNativeQuery;


@Entity
@NamedNativeQuery(name = "findDistinctLocality", 
				  query = "select locality_name from \"DIST_LOCALITIES\" " +
				  		"where upper(locality_name) like upper(:paramMatchString) " +
				  		"order by locality_name", 
				  resultClass = RefDistinctLocality.class)
public class RefDistinctLocality {

//	@Id
//    @Column(name = "LOCALITY_COD")
//    private String localityCod;
    
	@Id
    @Column(name = "LOCALITY_NAME")
    private String localityName;

    
//	public String getLocalityCod() {
//		return localityCod;
//	}
//
//	public void setLocalityCod(String localityCod) {
//		this.localityCod = localityCod;
//	}

	public String getLocalityName() {
		return localityName;
	}

	public void setLocalityName(String localityName) {
		this.localityName = localityName;
	}

    
	
}
